using SqlSugar;

/*
 * @author : xkdong@163.com
 * @date : 2024-3-15
 * @desc : 预约体检表
 */
namespace YOUYOU.Models.Entities.DBModels
{
    /// <summary>
    /// 预约体检表
    /// </summary>
    [SugarTable("appoint_checkup", TableDescription = "预约体检表")]
    public class AppointCheckup
    {
        /// <summary>
        /// 预约体检ID（自增）
        /// </summary>
        [SugarColumn(ColumnName = "ID", IsIdentity = true, IsPrimaryKey = true)]
        public int ID { get; set; }

        /// <summary>
        /// 病人ID(关联病人建档表)
        /// </summary>
        [SugarColumn(ColumnName = "PatientID")]
        public string? PatientID { get; set; }

        /// <summary>
        /// 预约日期和时间
        /// </summary>
        [SugarColumn(ColumnName = "AppointmentDate")]
        public DateTime? AppointmentDate { get; set; }

        /// <summary>
        /// 体检科室ID（关联科室表）
        /// </summary>
        [SugarColumn(ColumnName = "DeptID")]
        public int? DeptID { get; set; }

        /// <summary>
        /// 体检医生ID（关联人员信息表）
        /// </summary>
        [SugarColumn(ColumnName = "DoctorID")]
        public int? DoctorID { get; set; }

        /// <summary>
        /// 体检类型或套餐（常规体检或专项检查等）
        /// </summary>
        [SugarColumn(ColumnName = "Type")]
        public string? Type { get; set; }

        /// <summary>
        /// 预约状态（1.已完成，2.未完成）
        /// </summary>
        [SugarColumn(ColumnName = "Status")]
        public int? Status { get; set; }

        /// <summary>
        /// 下单时间（记录此次预约创建的时间)
        /// </summary>
        [SugarColumn(ColumnName = "CreationDate")]
        public DateTime? CreationDate { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        [SugarColumn(ColumnName = "Description")]
        public string? Description { get; set; }

    }
}